ALTER TABLE [X_Config] NOCHECK CONSTRAINT ALL
GO
ALTER TABLE [X_Config] DISABLE TRIGGER ALL
GO

SET IDENTITY_INSERT [X_Config] ON 
PRINT 'Begin inserting data in X_Config'
INSERT INTO [X_Config] ([Id], [ConfigKey], [ConfigValue], [Remark])
VALUES(1, 'Title', '企业综合管理系统框架', '网站的标题')
INSERT INTO [X_Config] ([Id], [ConfigKey], [ConfigValue], [Remark])
VALUES(5, 'PageSize', '15', '表格数据每页显示的个数')
INSERT INTO [X_Config] ([Id], [ConfigKey], [ConfigValue], [Remark])
VALUES(6, 'HelpList', '[{
    "Text": "万年历",
    "Icon": "Calendar",
    "ID": "wannianli",
    "URL": "~/admin/help/wannianli.htm"
},
{
    "Text": "科学计算器",
    "Icon": "Calculator",
    "ID": "jisuanqi",
    "URL": "~/admin/help/jisuanqi.htm"
},
{
    "Text": "系统帮助",
    "Icon": "Help",
    "ID": "help",
    "URL": "~/admin/help/help.htm"
}]', '帮助下拉列表')
SET IDENTITY_INSERT [X_Config] OFF 
ALTER TABLE [X_Config] CHECK CONSTRAINT ALL
GO

ALTER TABLE [X_Config] ENABLE TRIGGER ALL
GO



ALTER TABLE [X_Dept] NOCHECK CONSTRAINT ALL
GO
ALTER TABLE [X_Dept] DISABLE TRIGGER ALL
GO

SET IDENTITY_INSERT [X_Dept] ON 
PRINT 'Begin inserting data in X_Dept'
INSERT INTO [X_Dept] ([Id], [Name], [Remark], [ParentDeptId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(2, '研发部', '', 0, 80, NULL, NULL, '2010-07-18 20:44:07', 'admin')
INSERT INTO [X_Dept] ([Id], [Name], [Remark], [ParentDeptId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(3, '开发部', NULL, 2, 100, NULL, NULL, NULL, NULL)
INSERT INTO [X_Dept] ([Id], [Name], [Remark], [ParentDeptId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(4, '测试部', NULL, 2, 100, NULL, NULL, NULL, NULL)
INSERT INTO [X_Dept] ([Id], [Name], [Remark], [ParentDeptId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(5, '销售部', '', 0, 90, NULL, NULL, '2010-07-18 20:43:57', 'admin')
INSERT INTO [X_Dept] ([Id], [Name], [Remark], [ParentDeptId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(6, '直销部', NULL, 5, 100, NULL, NULL, NULL, NULL)
INSERT INTO [X_Dept] ([Id], [Name], [Remark], [ParentDeptId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(7, '渠道部', NULL, 5, 100, NULL, NULL, NULL, NULL)
INSERT INTO [X_Dept] ([Id], [Name], [Remark], [ParentDeptId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(8, '客服部', NULL, 0, 100, NULL, NULL, NULL, NULL)
INSERT INTO [X_Dept] ([Id], [Name], [Remark], [ParentDeptId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(9, '实施部', NULL, 8, 100, NULL, NULL, NULL, NULL)
INSERT INTO [X_Dept] ([Id], [Name], [Remark], [ParentDeptId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(10, '售后服务部', NULL, 8, 100, NULL, NULL, NULL, NULL)
INSERT INTO [X_Dept] ([Id], [Name], [Remark], [ParentDeptId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(11, '大客户服务部', NULL, 8, 100, NULL, NULL, NULL, NULL)
INSERT INTO [X_Dept] ([Id], [Name], [Remark], [ParentDeptId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(12, '财务部', NULL, 0, 100, NULL, NULL, NULL, NULL)
INSERT INTO [X_Dept] ([Id], [Name], [Remark], [ParentDeptId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(14, '行政部', NULL, 0, 100, NULL, NULL, NULL, NULL)
INSERT INTO [X_Dept] ([Id], [Name], [Remark], [ParentDeptId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(15, '人事部', NULL, 14, 100, NULL, NULL, NULL, NULL)
INSERT INTO [X_Dept] ([Id], [Name], [Remark], [ParentDeptId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(16, '后勤部', NULL, 14, 100, NULL, NULL, NULL, NULL)
INSERT INTO [X_Dept] ([Id], [Name], [Remark], [ParentDeptId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(17, '运输部', NULL, 14, 100, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [X_Dept] OFF 
ALTER TABLE [X_Dept] CHECK CONSTRAINT ALL
GO

ALTER TABLE [X_Dept] ENABLE TRIGGER ALL
GO



ALTER TABLE [X_JobTitle] NOCHECK CONSTRAINT ALL
GO
ALTER TABLE [X_JobTitle] DISABLE TRIGGER ALL
GO

SET IDENTITY_INSERT [X_JobTitle] ON 
PRINT 'Begin inserting data in X_JobTitle'
INSERT INTO [X_JobTitle] ([Id], [Name], [Remark], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(1, '软件工程师', NULL, NULL, NULL, NULL, NULL)
INSERT INTO [X_JobTitle] ([Id], [Name], [Remark], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(3, '部门经理', NULL, NULL, NULL, NULL, NULL)
INSERT INTO [X_JobTitle] ([Id], [Name], [Remark], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(5, '测试工程师', NULL, NULL, NULL, NULL, NULL)
INSERT INTO [X_JobTitle] ([Id], [Name], [Remark], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(6, '客户经理', NULL, NULL, NULL, '2010-07-18 00:04:42', 'admin')
INSERT INTO [X_JobTitle] ([Id], [Name], [Remark], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(7, '项目经理', NULL, NULL, NULL, NULL, NULL)
INSERT INTO [X_JobTitle] ([Id], [Name], [Remark], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(8, '财务经理', NULL, NULL, NULL, NULL, NULL)
INSERT INTO [X_JobTitle] ([Id], [Name], [Remark], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(10, '后勤人员', NULL, NULL, NULL, NULL, NULL)
INSERT INTO [X_JobTitle] ([Id], [Name], [Remark], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(11, '总裁', NULL, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [X_JobTitle] OFF 
ALTER TABLE [X_JobTitle] CHECK CONSTRAINT ALL
GO

ALTER TABLE [X_JobTitle] ENABLE TRIGGER ALL
GO



ALTER TABLE [X_Log] NOCHECK CONSTRAINT ALL
GO
ALTER TABLE [X_Log] DISABLE TRIGGER ALL
GO

SET IDENTITY_INSERT [X_Log] ON 
PRINT 'Begin inserting data in X_Log'
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(13, '2009-08-19 13:57:38', '1', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(14, '2009-08-19 14:03:54', '1', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(15, '2009-08-19 14:05:37', '11', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(16, '2009-08-25 14:54:48', '10', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(17, '2009-08-25 15:24:28', '14', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(18, '2009-08-25 15:32:04', '12', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(19, '2009-08-25 15:45:47', '12', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(20, '2009-08-25 16:14:22', '12', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(21, '2009-08-31 10:09:52', '7', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(22, '2009-09-08 21:47:38', '1', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(23, '2009-09-08 22:16:27', '7', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(24, '2009-09-12 17:28:16', '5', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(25, '2009-09-12 21:22:07', '5', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(26, '2009-09-12 22:18:51', '5', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(27, '2009-09-12 22:23:57', '9', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(28, '2009-09-12 23:33:46', '5', 'ERROR', 'AppBox._default', '这是个测试的日志', 'System.DivideByZeroException: 试图除以零。
   在 AppBox._default.Page_Load(Object sender, EventArgs e) 位置 D:\AppBox\AppBox\default.aspx.cs:行号 29')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(29, '2009-09-12 23:33:52', '5', 'ERROR', 'AppBox._default', '这是个测试的日志', 'System.DivideByZeroException: 试图除以零。
   在 AppBox._default.Page_Load(Object sender, EventArgs e) 位置 D:\AppBox\AppBox\default.aspx.cs:行号 29')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(30, '2009-09-12 23:33:53', '5', 'ERROR', 'AppBox._default', '这是个测试的日志', 'System.DivideByZeroException: 试图除以零。
   在 AppBox._default.Page_Load(Object sender, EventArgs e) 位置 D:\AppBox\AppBox\default.aspx.cs:行号 29')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(31, '2009-09-12 23:33:53', '5', 'ERROR', 'AppBox._default', '这是个测试的日志', 'System.DivideByZeroException: 试图除以零。
   在 AppBox._default.Page_Load(Object sender, EventArgs e) 位置 D:\AppBox\AppBox\default.aspx.cs:行号 29')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(32, '2009-09-12 23:33:53', '5', 'ERROR', 'AppBox._default', '这是个测试的日志', 'System.DivideByZeroException: 试图除以零。
   在 AppBox._default.Page_Load(Object sender, EventArgs e) 位置 D:\AppBox\AppBox\default.aspx.cs:行号 29')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(33, '2009-09-12 23:33:53', '5', 'ERROR', 'AppBox._default', '这是个测试的日志', 'System.DivideByZeroException: 试图除以零。
   在 AppBox._default.Page_Load(Object sender, EventArgs e) 位置 D:\AppBox\AppBox\default.aspx.cs:行号 29')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(34, '2009-09-12 23:33:53', '5', 'ERROR', 'AppBox._default', '这是个测试的日志', 'System.DivideByZeroException: 试图除以零。
   在 AppBox._default.Page_Load(Object sender, EventArgs e) 位置 D:\AppBox\AppBox\default.aspx.cs:行号 29')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(35, '2009-09-12 23:33:54', '5', 'ERROR', 'AppBox._default', '这是个测试的日志', 'System.DivideByZeroException: 试图除以零。
   在 AppBox._default.Page_Load(Object sender, EventArgs e) 位置 D:\AppBox\AppBox\default.aspx.cs:行号 29')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(36, '2009-09-12 23:33:54', '5', 'ERROR', 'AppBox._default', '这是个测试的日志', 'System.DivideByZeroException: 试图除以零。
   在 AppBox._default.Page_Load(Object sender, EventArgs e) 位置 D:\AppBox\AppBox\default.aspx.cs:行号 29')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(37, '2009-09-12 23:33:54', '5', 'ERROR', 'AppBox._default', '这是个测试的日志', 'System.DivideByZeroException: 试图除以零。
   在 AppBox._default.Page_Load(Object sender, EventArgs e) 位置 D:\AppBox\AppBox\default.aspx.cs:行号 29')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(38, '2009-09-12 23:33:54', '5', 'ERROR', 'AppBox._default', '这是个测试的日志', 'System.DivideByZeroException: 试图除以零。
   在 AppBox._default.Page_Load(Object sender, EventArgs e) 位置 D:\AppBox\AppBox\default.aspx.cs:行号 29')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(39, '2009-09-13 15:44:34', '1', 'ERROR', 'AppBox._default', '这是个测试的日志', 'System.DivideByZeroException: 试图除以零。
   在 AppBox._default.Page_Load(Object sender, EventArgs e) 位置 D:\AppBox\AppBox\default.aspx.cs:行号 29')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(40, '2009-09-13 15:44:56', '1', 'ERROR', 'AppBox._default', '这是个测试的日志', 'System.DivideByZeroException: 试图除以零。
   在 AppBox._default.Page_Load(Object sender, EventArgs e) 位置 D:\AppBox\AppBox\default.aspx.cs:行号 29')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(41, '2009-09-13 15:45:42', '1', 'ERROR', 'AppBox._default', '这是个测试的日志', 'System.DivideByZeroException: 试图除以零。
   在 AppBox._default.Page_Load(Object sender, EventArgs e) 位置 D:\AppBox\AppBox\default.aspx.cs:行号 29')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(42, '2009-09-13 15:45:42', '1', 'ERROR', 'AppBox._default', '这是个测试的日志', 'System.DivideByZeroException: 试图除以零。
   在 AppBox._default.Page_Load(Object sender, EventArgs e) 位置 D:\AppBox\AppBox\default.aspx.cs:行号 29')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(43, '2009-09-13 15:45:43', '1', 'ERROR', 'AppBox._default', '这是个测试的日志', 'System.DivideByZeroException: 试图除以零。
   在 AppBox._default.Page_Load(Object sender, EventArgs e) 位置 D:\AppBox\AppBox\default.aspx.cs:行号 29')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(44, '2009-09-13 15:45:43', '1', 'ERROR', 'AppBox._default', '这是个测试的日志', 'System.DivideByZeroException: 试图除以零。
   在 AppBox._default.Page_Load(Object sender, EventArgs e) 位置 D:\AppBox\AppBox\default.aspx.cs:行号 29')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(46, '2009-09-13 15:45:43', '1', 'ERROR', 'AppBox._default', '这是个测试的日志', 'System.DivideByZeroException: 试图除以零。
   在 AppBox._default.Page_Load(Object sender, EventArgs e) 位置 D:\AppBox\AppBox\default.aspx.cs:行号 29')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(47, '2009-09-13 15:45:43', '1', 'ERROR', 'AppBox._default', '这是个测试的日志', 'System.DivideByZeroException: 试图除以零。
   在 AppBox._default.Page_Load(Object sender, EventArgs e) 位置 D:\AppBox\AppBox\default.aspx.cs:行号 29')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(61, '2009-09-13 15:50:31', '9', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(63, '2009-09-13 21:05:54', '12', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(64, '2009-09-14 21:06:47', '7', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(65, '2009-09-14 22:51:26', '11', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(66, '2009-09-15 18:37:40', '1', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(67, '2009-09-15 18:38:50', '1', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(68, '2009-09-15 18:38:50', '1', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(69, '2009-09-15 20:58:38', '8', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(70, '2009-09-16 21:44:50', '1', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(71, '2010-02-06 11:59:16', '5', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(72, '2010-02-06 12:15:05', '9', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(73, '2010-02-07 10:49:26', '1', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(74, '2010-02-07 17:15:43', '8', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(75, '2010-02-07 17:52:57', '10', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(76, '2010-02-07 20:34:54', '1', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(77, '2010-07-09 21:50:25', '5', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(78, '2010-07-09 21:52:43', '5', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(79, '2010-07-09 21:53:21', '5', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(80, '2010-07-09 21:58:38', '5', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(81, '2010-07-09 21:59:01', '5', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(82, '2010-07-09 22:29:13', '5', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(83, '2010-07-10 13:03:40', '7', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(84, '2010-07-10 13:30:53', '1', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(85, '2010-07-10 15:27:32', '1', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(86, '2010-07-10 20:39:15', '9', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(87, '2010-07-10 21:19:15', '9', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(88, '2010-07-11 00:17:31', '14', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(89, '2010-07-12 21:29:30', '1', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(90, '2010-07-12 21:29:36', '8', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(91, '2010-07-12 21:32:13', '1', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(92, '2010-07-17 11:56:11', '7', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(93, '2010-07-17 22:15:27', '1', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(94, '2010-07-18 00:31:08', '12', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(95, '2010-07-18 14:11:19', '6', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(96, '2010-07-18 19:25:55', '6', 'WARN', 'AppBox._default', '登录失败：用户“admin”密码错误', '')
INSERT INTO [X_Log] ([LOGID], [DATETIME], [THREAD], [LOG_LEVEL], [LOGGER], [MESSAGE], [EXCEPTION])
VALUES(97, '2010-07-18 19:25:59', '9', 'INFO', 'AppBox._default', '登录成功：用户“admin”', '')
SET IDENTITY_INSERT [X_Log] OFF 
ALTER TABLE [X_Log] CHECK CONSTRAINT ALL
GO

ALTER TABLE [X_Log] ENABLE TRIGGER ALL
GO



ALTER TABLE [X_Menu] NOCHECK CONSTRAINT ALL
GO
ALTER TABLE [X_Menu] DISABLE TRIGGER ALL
GO

SET IDENTITY_INSERT [X_Menu] ON 
PRINT 'Begin inserting data in X_Menu'
INSERT INTO [X_Menu] ([Id], [Name], [ImageUrl], [NavigateUrl], [IsMainMenu], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(2, '系统管理', '', '', 1, NULL, 0, 10, NULL, NULL, '2008-12-30 17:33:41', 'admin')
INSERT INTO [X_Menu] ([Id], [Name], [ImageUrl], [NavigateUrl], [IsMainMenu], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(4, '职务管理', '', '~/admin/jobtitle.aspx', 1, NULL, 2, 30, NULL, NULL, '2010-02-06 20:56:20', 'admin')
INSERT INTO [X_Menu] ([Id], [Name], [ImageUrl], [NavigateUrl], [IsMainMenu], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(5, '部门管理', '', '~/admin/dept.aspx', 1, NULL, 2, 40, NULL, NULL, '2008-12-31 10:44:30', 'admin')
INSERT INTO [X_Menu] ([Id], [Name], [ImageUrl], [NavigateUrl], [IsMainMenu], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(6, '菜单管理', '', '~/admin/menu.aspx', 1, NULL, 2, 20, NULL, NULL, '2010-02-06 20:53:38', 'admin')
INSERT INTO [X_Menu] ([Id], [Name], [ImageUrl], [NavigateUrl], [IsMainMenu], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(7, '角色管理', '', '~/admin/role.aspx', 1, NULL, 2, 60, NULL, NULL, '2008-12-31 10:42:41', 'admin')
INSERT INTO [X_Menu] ([Id], [Name], [ImageUrl], [NavigateUrl], [IsMainMenu], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(8, '用户管理', '', '~/admin/user.aspx', 1, NULL, 2, 70, NULL, NULL, '2008-12-31 10:44:42', 'admin')
INSERT INTO [X_Menu] ([Id], [Name], [ImageUrl], [NavigateUrl], [IsMainMenu], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(9, '用户权限配置', '', '~/admin/userright.aspx', 1, NULL, 2, 80, NULL, NULL, NULL, NULL)
INSERT INTO [X_Menu] ([Id], [Name], [ImageUrl], [NavigateUrl], [IsMainMenu], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(10, '日志管理', '', '~/admin/log.aspx', 1, NULL, 2, 90, NULL, NULL, NULL, NULL)
INSERT INTO [X_Menu] ([Id], [Name], [ImageUrl], [NavigateUrl], [IsMainMenu], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(11, '办公平台', '', '', 1, NULL, 0, 100, NULL, NULL, '2008-12-31 09:29:39', 'admin')
INSERT INTO [X_Menu] ([Id], [Name], [ImageUrl], [NavigateUrl], [IsMainMenu], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(12, '文件发布', '', '~/admin/file.aspx', 1, NULL, 11, 110, NULL, NULL, '2008-12-31 09:59:20', 'admin')
INSERT INTO [X_Menu] ([Id], [Name], [ImageUrl], [NavigateUrl], [IsMainMenu], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(24, '测试目录', '', '~/admin/test.aspx', 1, NULL, 11, 135, NULL, NULL, NULL, NULL)
INSERT INTO [X_Menu] ([Id], [Name], [ImageUrl], [NavigateUrl], [IsMainMenu], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(25, '测试子目录', '', '~/admin/test2.aspx', 1, NULL, 24, 136, NULL, NULL, NULL, NULL)
INSERT INTO [X_Menu] ([Id], [Name], [ImageUrl], [NavigateUrl], [IsMainMenu], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(29, '系统配置', '', '~/admin/config.aspx', 1, NULL, 2, 91, NULL, NULL, NULL, NULL)
INSERT INTO [X_Menu] ([Id], [Name], [ImageUrl], [NavigateUrl], [IsMainMenu], [Remark], [ParentMenuId], [SortIndex], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(30, '修改密码', '', '~/admin/changepassword.aspx', 1, NULL, 2, 92, '2010-07-12 21:35:37', 'admin', '2010-07-12 21:35:37', 'admin')
SET IDENTITY_INSERT [X_Menu] OFF 
ALTER TABLE [X_Menu] CHECK CONSTRAINT ALL
GO

ALTER TABLE [X_Menu] ENABLE TRIGGER ALL
GO



ALTER TABLE [X_Role] NOCHECK CONSTRAINT ALL
GO
ALTER TABLE [X_Role] DISABLE TRIGGER ALL
GO

SET IDENTITY_INSERT [X_Role] ON 
PRINT 'Begin inserting data in X_Role'
INSERT INTO [X_Role] ([Id], [Name], [Remark], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(1, '系统管理员', '', NULL, NULL, '2010-07-18 22:46:22', 'admin')
INSERT INTO [X_Role] ([Id], [Name], [Remark], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(2, '部门管理员', NULL, NULL, NULL, NULL, NULL)
INSERT INTO [X_Role] ([Id], [Name], [Remark], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(3, '员工', NULL, NULL, NULL, NULL, NULL)
INSERT INTO [X_Role] ([Id], [Name], [Remark], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(4, '外包人员', NULL, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [X_Role] OFF 
ALTER TABLE [X_Role] CHECK CONSTRAINT ALL
GO

ALTER TABLE [X_Role] ENABLE TRIGGER ALL
GO



ALTER TABLE [X_User] NOCHECK CONSTRAINT ALL
GO
ALTER TABLE [X_User] DISABLE TRIGGER ALL
GO

SET IDENTITY_INSERT [X_User] ON 
PRINT 'Begin inserting data in X_User'
INSERT INTO [X_User] ([Id], [Name], [Password], [Email], [Enabled], [Remark], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy])
VALUES(3, 'admin', '/e0oVLJSOz+iEXnVM0smhzjLOdLuCXTj', NULL, 1, NULL, '2008-12-27 18:13:51', 'AppBox.Web.Init', '2010-07-12 21:49:26', 'admin')
SET IDENTITY_INSERT [X_User] OFF 
ALTER TABLE [X_User] CHECK CONSTRAINT ALL
GO

ALTER TABLE [X_User] ENABLE TRIGGER ALL
GO



ALTER TABLE [X_UserConfig] NOCHECK CONSTRAINT ALL
GO
ALTER TABLE [X_UserConfig] DISABLE TRIGGER ALL
GO

SET IDENTITY_INSERT [X_UserConfig] ON 
PRINT 'Begin inserting data in X_UserConfig'
SET IDENTITY_INSERT [X_UserConfig] OFF 
ALTER TABLE [X_UserConfig] CHECK CONSTRAINT ALL
GO

ALTER TABLE [X_UserConfig] ENABLE TRIGGER ALL
GO



